There is an error when i run my xpages, the getSQLData is my serverside javascript function
and how i close the debug info
<?xml version="1.0" encoding="UTF-8"?>
<xp:view xmlns:xp="http://www.ibm.com/xsp/core">
<xp:this.resources>
<xp:script src="/SQLFunction.jss" clientSide="false"></xp:script>
</xp:this.resources>
<xp:comboBox id="comboBox1">
<xp:selectItems>
<xp:this.value><![CDATA[#{javascript:@Explode(getSQLData())}]]></xp:this.value>
</xp:selectItems>
</xp:comboBox>
</xp:view>
function getSQLData() {
//var query=compositeData.SQLQuery;
//var rs:java.sql.ResultSet = javaMethods.SQLFunction.executeQuery(query);
//var rsmd:java.sql.ResultSetMetaData = rs.getMetaData();
var out = [];
var row = [];
row.push("1111");
out.push(row);
var row = [];
row.push("2222");
out.push(row);
//while (rs.next()){
// print(rs.getRow());
// var row = new Array();
// for (i=1; i<rsmd.getColumnCount()+1; i++) {
// switch (rsmd.getColumnType(i))
// { case 12: row.push(rs.getString(i));
// break;
// case 4: row.push(rs.getInt(i));
// break;
// default: row.push(rs.getString(i));
// }
// }
// out.push(row);
// }
return out;
}
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.application.ApplicationImpl -85882250 [Thread-7] DEBUG com.sun.faces.application.ApplicationImpl - Couldn't find a factory for @Explode
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.el.VariableResolverImpl -85882250 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:null
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.application.ApplicationImpl -85882250 [Thread-7] DEBUG com.sun.faces.application.ApplicationImpl - Couldn't find a factory for getSQLData
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,019 - com.sun.faces.el.VariableResolverImpl -85871346 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,019 - com.sun.faces.el.VariableResolverImpl -85871346 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,019 - com.sun.faces.el.VariableResolverImpl -85871346 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,019 - com.sun.faces.el.VariableResolverImpl -85871346 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,019 - com.sun.faces.el.VariableResolverImpl -85871346 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,019 - com.sun.faces.el.VariableResolverImpl -85871346 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,020 - com.sun.faces.el.VariableResolverImpl -85871347 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,020 - com.sun.faces.el.VariableResolverImpl -85871347 [Thread-8] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@6e966e96
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:38 HTTP JVM: [connection] 2012-02-03 15:16:38,020 - com.sun.faces.lifecycle.RenderResponsePhase -85871347 [Thread-8] DEBUG com.sun.faces.lifecycle.RenderResponsePhase - Exiting RenderResponsePhase
2012-02-03 15:16:38 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,922 - com.sun.faces.lifecycle.LifecycleImpl -85882249 [Thread-7] DEBUG com.sun.faces.lifecycle.LifecycleImpl - render(com.ibm.xsp.domino.context.DominoFacesContext@61d661d6)
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,922 - com.sun.faces.lifecycle.LifecycleImpl -85882249 [Thread-7] DEBUG com.sun.faces.lifecycle.LifecycleImpl - phase(RENDER_RESPONSE 6,com.ibm.xsp.domino.context.DominoFacesContext@61d661d6)
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,922 - com.sun.faces.lifecycle.RenderResponsePhase -85882249 [Thread-7] DEBUG com.sun.faces.lifecycle.RenderResponsePhase - Entering RenderResponsePhase
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,922 - com.sun.faces.lifecycle.RenderResponsePhase -85882249 [Thread-7] DEBUG com.sun.faces.lifecycle.RenderResponsePhase - About to render view /sample
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,922 - com.sun.faces.renderkit.html_basic.FormRenderer -85882249 [Thread-7] DEBUG com.sun.faces.renderkit.html_basic.FormRenderer - Begin encoding component _id1
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,922 - com.sun.faces.application.ViewHandlerImpl -85882249 [Thread-7] DEBUG com.sun.faces.application.ViewHandlerImpl - servletPath /sample.xsp
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,922 - com.sun.faces.application.ViewHandlerImpl -85882249 [Thread-7] DEBUG com.sun.faces.application.ViewHandlerImpl - pathInfo null
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.application.ViewHandlerImpl -85882250 [Thread-7] DEBUG com.sun.faces.application.ViewHandlerImpl - URL pattern of the FacesServlet executing the current request .xsp
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.renderkit.html_basic.MenuRenderer -85882250 [Thread-7] DEBUG com.sun.faces.renderkit.html_basic.MenuRenderer - Begin encoding component comboBox1
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.renderkit.html_basic.MenuRenderer -85882250 [Thread-7] DEBUG com.sun.faces.renderkit.html_basic.MenuRenderer - Rendering 'select'
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.application.ApplicationImpl -85882250 [Thread-7] DEBUG com.sun.faces.application.ApplicationImpl - Couldn't find a factory for @Explode
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.el.VariableResolverImpl -85882250 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:null
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.application.ApplicationImpl -85882250 [Thread-7] DEBUG com.sun.faces.application.ApplicationImpl - Couldn't find a factory for getSQLData
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.el.VariableResolverImpl -85882250 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:null
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,923 - com.sun.faces.renderkit.html_basic.MenuRenderer -85882250 [Thread-7] DEBUG com.sun.faces.renderkit.html_basic.MenuRenderer - Rendering 2 options
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.application.ApplicationImpl -85882251 [Thread-7] DEBUG com.sun.faces.application.ApplicationImpl - Couldn't find a factory for @Explode
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.el.VariableResolverImpl -85882251 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:null
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.application.ApplicationImpl -85882251 [Thread-7] DEBUG com.sun.faces.application.ApplicationImpl - Couldn't find a factory for getSQLData
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.el.VariableResolverImpl -85882251 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:null
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.renderkit.html_basic.MenuRenderer -85882251 [Thread-7] DEBUG com.sun.faces.renderkit.html_basic.MenuRenderer - End encoding component comboBox1
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.renderkit.html_basic.FormRenderer -85882251 [Thread-7] DEBUG com.sun.faces.renderkit.html_basic.FormRenderer - End encoding component _id1
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.el.VariableResolverImpl -85882251 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.el.VariableResolverImpl -85882251 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,924 - com.sun.faces.el.VariableResolverImpl -85882251 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,925 - com.sun.faces.el.VariableResolverImpl -85882252 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,925 - com.sun.faces.el.VariableResolverImpl -85882252 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,925 - com.sun.faces.el.VariableResolverImpl -85882252 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,925 - com.sun.faces.el.VariableResolverImpl -85882252 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,925 - com.sun.faces.el.VariableResolverImpl -85882252 [Thread-7] DEBUG com.sun.faces.el.VariableResolverImpl - resolveVariable: Resolved variable:com.ibm.xsp.designer.context.ServletXSPContext@7f127f12
2012-02-03 15:16:49 HTTP JVM:
2012-02-03 15:16:49 HTTP JVM: [connection] 2012-02-03 15:16:48,926 - com.sun.faces.lifecycle.RenderResponsePhase -85882253 [Thread-7] DEBUG com.sun.faces.lifecycle.RenderResponsePhase - Exiting RenderResponsePhase